# coding:utf-8
item = {"updatetime": "04-24", "keyword": "HTML5开发", "title": "\r\n                                    HTML5开发助理+无经验可实习+五险一金                                ",
    "company": "北京优才创智科技有限公司", "link": "http://jobs.51job.com/shanghai-bsq/88421606.html?s=01&t=0", "location": "上海"}

from openpyxl import Workbook
from openpyxl.compat import range
from openpyxl.utils import get_column_letter

from xlrd import open_workbook
from xlutils.copy import copy

print type(item.values())

wb = Workbook()
sheet1 = wb.active
print sheet1.title
sheet1.append(item.values())
wb.save('demo.xlsx')
# wb = Workbook()
# dest_filename = 'jobs.xlsx'
# sheet1 = wb.active
# sheet1.title = "hello"

# for row in range(1,40):
#     sheet1.append(range(600))

# sheet2 = wb.create_sheet(title = 'pi')
# sheet2['F5'] = 3.14


# ws3 = wb.create_sheet(title="Data")
# for row in range(10, 20):
#     for col in range(27, 54):
#         _ = ws3.cell(column=col, row=row, value="{0}".format(get_column_letter(col)))
# wb.save(filename = dest_filename)
